Create Bookmark and KPI'S 10

             Create Bookmark 


 Create Slicer visible Bookmark

·       Go to Modeling

·       Select Bookmark and Selection

·       From Bookmark Click Add

·       Click the three dots and Select Rename Slicer visible

·       Click the three dots unselect data

·       Go to the Format button select Action

-        Type -----Bookmark

-        Bookmark ------Slicer visible

Create Slicer Invisible Bookmark

·       Go to Modeling

·       Select Bookmark and Selection

·       From Bookmark Click Add

·       Click the three dots and Select Rename Slicer Invisible

·       Click the three dots unselect data

·       Hid the Group1 from the selection

·       Click Update from the three dots

·       Go to the Format button select Action

-        Type -----Bookmark

-        Bookmark ------Slicer visible



               Create KPI’S

                       ·       Download the doc and click ok



1. TOTAL MEMBER KPI

STEP 1

·       Go to insert

·       Select Rectangle from Shapes

General

-        X-Position 0

-        Y-Position 264

-        Width       360

-        Height     120

                                     Background

-        Color Black

-        Transparency 78%

Put everything else off

STEP 2

·       Select Card visual

·       Drag and drop Total member  

General

-        X-Position 96

-        Y-Position 312

-        Width       144

-        Height       72

                                     Data Label

-        Color Black

-        Text Size 40

Put everything else off

STEP 3

·       Go to insert

·       Select image from a folder

General

-        X-Position 120

-        Y-Position 264

-        Width       144

-        Height     48

Put everything else off

STEP 4

·       Go to insert

·       Select Text box

·       Write TOTAL MEMBER

-        Choose Time New Roman, Text Size 20, and make it Center

Format text box

General

-        X-Position 120

-        Y-Position 264

-        Width       144

-        Height     48

                                      Background

-        Color Black

-        Transparency 78%


2. FIRST RESPONSE KPI

STEP 1

·       Go to insert

·       Select Rectangle from Shapes

General

-        X-Position 360

-        Y-Position 264

-        Width       384

-        Height     120

                                     Background

-        Color Black

-        Transparency 78%

Put everything else off

STEP 2

·       Select Card visual

·       Drag and drop First Response Time

General

-        X-Position 432

-        Y-Position 312

-        Width       168

-        Height       72

                                     Data Label

-        Color



-        Text Size 40

 

·       Select Card visual

·       Drag and drop Response Time Units

General

-        X-Position 576

-        Y-Position 336

-        Width       120

-        Height       48

                                     Data Label

-        Color

 

Put everything else off

STEP 3

·       Go to insert

·       Select image from Folder

General

-        X-Position 504

-        Y-Position 264

-        Width       96

-        Height     48

Put everything else off

STEP 4

·       Go to insert

·       Select Text box

·       Write FIRST RESPONSE TIME

-        Choose Time New Roman, Text Size 20, and make it Center

Format text box

General

-        X-Position 120

-        Y-Position 264

-        Width       144

-        Height     48

                                      Background

-        Color Black

-        Transparency 78%



3. CONTRIBUTIONS KPI

STEP 1

·       Go to insert

·       Select Rectangle from Shapes

General

-        X-Position 744

-        Y-Position 264

-        Width       336

-        Height     120

                                     Background

-        Color Black

-        Transparency 78%

Put everything else off

STEP 2

·       Select Card visual

·       Drag and drop Total Contributors   

General

-        X-Position 840

-        Y-Position 312

-        Width       144

-        Height       72

                                     Data Label

-        Color Black

-        Text Size 40

Put everything else off

STEP 3

·       Go to insert

·       Select image from a folder

General

-        X-Position 840

-        Y-Position 264

-        Width       144

-        Height     48

Put everything else off

STEP 4

·       Go to insert

·       Select Text box

·       Write CONTRIBUTIONS

-        Choose Time New Roman, Text Size 20, and make it Center

Format text box

General

-        X-Position 744

-        Y-Position 384

-        Width       336

-        Height     48

                                      Background

-        Color Black

-        Transparency 78%

4. TOTAL QUESTIONS

STEP 1

·       Go to insert

·       Select Rectangle from Shapes

General

-        X-Position 1080

-        Y-Position 264

-        Width       336

-        Height     120

                                     Background

-        Color Black

-        Transparency 78%

Put everything else off

STEP 2

·       Select Card visual

·       Drag and drop Total Contributors  

General

-        X-Position 1152

-        Y-Position 312

-        Width       192

-        Height       72

                                     Data Label

-        Color Black

-        Text Size 40

Put everything else off

STEP 3

·       Go to insert

·       Select image from Folder

General

-        X-Position 1176

-        Y-Position 240

-        Width       144

-        Height      96

Put everything else off

STEP 4

·       Go to insert

·       Select Text box

·       Write TOTAL QUESTIONS

-        Choose Time New Roman, Text Size 20, and make it Center

Format text box

General

-        X-Position 1080

-        Y-Position 384

-        Width       336

-        Height     48

                                      Background

-        Color Black

-        Transparency 78%

 

 

5. NOT RESPONDED %

STEP 1

·       Go to insert

·       Select Rectangle from Shapes

General

-        X-Position 1416

-        Y-Position 264

-        Width       360

-        Height     120

                                     Background

-        Color Black

-        Transparency 78%

Put everything else off

STEP 2

·       Select Card visual

·       Drag and drop % Of Not Responded Qns

General

-        X-Position 1440

-        Y-Position 312

-        Width        288

-        Height       72

                                     Data Label

-        Color Black

-        Text Size 40

Put everything else off

STEP 3

·       Go to insert

·       Select image from Folder

General

-        X-Position 1536

-        Y-Position 264

-        Width       96

-        Height      48

Put everything else off

STEP 4

·       Go to insert

·       Select Text box

·       Write NOT RESPONDED %

-        Choose Time New Roman, Text Size 20, and make it Center

Format text box

General

-        X-Position 1416

-        Y-Position 384

-        Width       360

-        Height     48

                                      Background

-        Color Black

-        Transparency 78%

 

6. CORRECT ANSWERS %

STEP 1

·       Go to insert

·       Select Rectangle from Shapes

General

-        X-Position 1776

-        Y-Position 264

-        Width       336

-        Height     120

                                     Background

-        Color Black

-        Transparency 78%

Put everything else off

STEP 2

·       Select Card visual

·       Drag and drop % of Not Responded

General

-        X-Position 1848

-        Y-Position 312

-        Width        168

-        Height       72

                                     Data Label

-        Color Black

-        Text Size 40

Put everything else off

STEP 3

·       Go to insert

·       Select image from Folder

General

-        X-Position 1872

-        Y-Position 264

-        Width       120

-        Height      48

Put everything else off

STEP 4

·       Go to insert

·       Select Text box

·       Write NOT RESPONDED %

-        Choose Time New Roman, Text Size 20, and make it a center

Format text box

General

-        X-Position 1776

-        Y-Position 384

-        Width       336

-        Height     48

                                      Background

-        Color Black

-        Transparency 78%


7. QUESTIONS PER DAY

STEP 1

·       Go to insert

·       Select Rectangle from Shapes

General

-        X-Position 2112

-        Y-Position 264

-        Width       384

-        Height     120

                                     Background

-        Color Black

-        Transparency 78%

Put everything else off

STEP 2

·       Select Card visual

·       Drag and drop % of Not Responded

General

-        X-Position 2208

-        Y-Position 312

-        Width        168

-        Height       72

                                     Data Label

-        Color Black

-        Text Size 40

Put everything else off

STEP 3

·       Go to insert

·       Select image from Folder

General

-        X-Position 2232

-        Y-Position 264

-        Width       120

-        Height      48

Put everything else off

STEP 4

·       Go to insert

·       Select Text box

·       Write NOT RESPONDED %

-        Choose Time New Roman, Text Size 20, and make it Center

Format text box

General

-        X-Position 2112

-        Y-Position 384

-        Width       384

-        Height      48

                                      Background

-        Color Black

-        Transparency 78%

How to create a KPI'S 

https://www.youtube.com/watch?v=9eKLdujI9_A

How to create a bookmark in power bi 

https://www.youtube.com/watch?v=r5anuXCeDRU